<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Removing totals</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { margin-left:0px; }
img_whs2 { border:none; width:277px; height:337px; border-style:none; }
ol.whs3 { list-style:decimal; }
p.whs4 { margin-top:0px; margin-bottom:0px; }
ul.whs5 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs1 {margin-left:1pt; }";
  strNSS += "p.whs4 {margin-top:1pt;margin-bottom:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nDisplaying and modifying grand totals and subtotals\nRemoving totals");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Removing totals</h1>
<p>It is not always necessary or desirable to have grand totals and subtotals 
 displayed in a report. Removing totals is different than hiding them. 
 When you remove totals on a report, you actually remove them from the 
 report definition. This means that when the report is re-executed, totals 
 will no longer be enabled for the report. You can remove certain totals 
 and let others remain on the report, or you can remove all totals from 
 the report.</p>
<h2>Prerequisites</h2>
<p>The steps below assume there are totals enabled for at least one metric 
 on the report.</p>
<h2>Warning</h2>
<p class="whs1">Do not clear (sub)totals without keeping a 
 record of the totals added originally. Removing them requires adding each 
 one back individually by checking the boxes shown below in the Subtotals 
 Editor: </p>
<p class="whs1"><img src="images/subtotals_editor.jpg" width="277px" height="337px" border="0" class="img_whs2"></p>
<h2>To remove totals from a report</h2>
<ol start="1" type="1" class="whs3">
	
<li class=p><p class="whs1">Click the name of a report 
 to execute it. The report must be in either Grid view or Grid and Graph 
 view.</p></li>
	
<li class=p><p class="whs4">From the 
 <span style="font-weight: bold;"><B>Data</B></span> menu, select <span style="font-weight: bold;"><B>Edit 
 Totals</B></span>. The Subtotals Editor is displayed.</p></li>
</ol>
<p class="whs4">&nbsp;</p>
<ol start="3" type="1" class="whs3">
	
<li class=p><p class="whs4">Click the 
 <span style="font-weight: bold;"><B>Definitions</B></span> tab.</p></li>
	
<li class=p><p>Clear the check boxes for the totals you no longer want 
 to see on the report. The selected totals are permanently removed from 
 the report.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span> to 
 confirm your changes and return to the report.</p></li>
</ol>
<h3>Related topics</h3>
<ul type="disc" class="whs5">
	
<li class=p><p>
<a HREF="Display_and_hide_totals.htm">Showing and hiding 
 all totals</a></p></li>
	
<li class=p><p>
<a HREF="Subtotals_dialog_box.htm">Subtotals dialog 
 box</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
